{"text_format":"2","workbook":"xlsx","n_sheets":1,"sheets":["Activity Sampling Template"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Activity Sampling Template","index":0,"n_rows":18,"n_cols":16,"rows_kept":18,"cut":false,"hidden":false,"merged":[[6,0,7,0],[1,5,1,6],[1,1,1,3]]}
[]
["Name of Area of Observation","Lego Production",null,null,"Date","2019-07-23",null,"Start Time","10:00:00","End Time","10:20:00",{"$nulls":4},"VA"]
[{"$nulls":15},"NVA"]
["Total",{"$f":"SUM(B8:B18)","v":0},405,83,0,94,0,0,18,0,0,{"$f":"SUM(F8:F18)","v":94}]
["% of Total",{"$f":"IFERROR(B4/SUM($B$4:$K$4),\"\")","v":0},{"$f":"IFERROR(C4/SUM($B$4:$K$4),\"\")","v":0.67500000000000004},0.13833333333333334,0,0.15666666666666668,0,0,0.03,0,0,{"$f":"SUM(F9:F18)","v":94}]
[{"$nulls":11},{"$f":"L4/(G4+L4)","v":1}]
["Operator Number or Name","Activity 1","Activity 2","Activity 3","Activity 4","Activity 5","Activity 6","Activity 7","Activity 8","Activity 9","Activity 10","% of total"]
[null,"Walking","Waiting","Pick Up/Put Down","Inspection","Orientation","Talk to Supervisor","Re-work","Operation"]
[1,null,75,20,null,20,null,null,5,null,null,{"$f":"D9/($L$4+$G$4)","v":0.21276595744680851}]
[2,null,77,19,null,20,null,null,4,null,null,0.20212765957446807]
[3,null,84,15,null,18,null,null,3,null,null,0.15957446808510639]
[4,null,85,15,null,17,null,null,3,null,null,0.15957446808510639]
[5,null,84,14,null,19,null,null,3,null,null,0.14893617021276595]
[6,{"$nulls":10},0]
[7,{"$nulls":10},0]
[8,{"$nulls":10},0]
[9,{"$nulls":10},0]
[10,{"$nulls":10},0]